package com.ncloud.billing.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.ncloud.billing.entity.BsProject;
@Mapper
public interface BsProjectMapper {
	
	@Select(value = {"SELECT project_id, cust_id, project_name, contact_name, contact_phone, test_flag, state, "
			+ "manager, create_time, create_user, destory_time, update_time, update_user, remark "
			+ "FROM bs_project where cust_id=#{cust_id}"})
	@Results({ @Result(column = "project_id", property = "projectId"), @Result(column = "cust_id", property = "custId"),
         @Result(column = "project_name", property = "projectName"),@Result(column = "contact_name", property = "contactName"),
         @Result(column="contact_phone",property="contactPhone"),@Result(column="test_flag",property="testFlag"),
         @Result(column="state",property="state"),@Result(column="manager",property="manager"),
         @Result(column="create_time",property="createTime"),@Result(column = "create_user", property = "createUser"),
         @Result(column="destory_time",property="destoryTime"),@Result(column = "update_time", property = "updateTime"),
         @Result(column="update_user",property="updateUser"),@Result(column = "remark", property = "remark")})
	public List<BsProject> getBsProjectByCustID(Long cust_id);
}